Debtors Aged Trial Balance Reports

You are here: 1. Distribution System > 1.9. REPORTS Menu > 1.9.5. Reports - Debtor Reports > 1.9.5.3. Debtor Reports - Aged Trial Balance

Debtor Reports - Aged Trial Balance

The debtors Aged Trial Balance is used to display each debtor with an outstanding account balance, with the debtor's outstanding invoices aged into their respective periods. The periods depend on the debtor's terms and can be setup for periods that are (normally) aged from the end of the month, but could be 7 days, 14 days, etc.

Reference

To print an Aged Trial Balance with transactions per debtor, refer to "Debtor Reports - Aged Trial Balance with Transactions".
To print an Aged Trial Balance that combines all your debtor balances and may be balanced to your System Summary, refer to "Debtor Reports - Aged Trial Balance Total".

Select REPORTS | DEBTOR REPORTS | AGED TRIAL BALANCE.

Micronet displays the Aged Trial Balance screen.

Select ORDER and then select one of the following options to choose the order in which you want the report sorted:

CUSTOMER - sort by debtor ID
SALES REP - sort by salesperson
SALES TERR - sort by sales territory
NAME - sort by debtor name
RUN NO. - sort by standing order run number
CLASS - sort by class.

Micronet places a tick beside the selected option.

Select FILE | RUN REPORT.

Micronet displays the Select Report screen with a list of report layout options created in the Report Generator.

Select a format for the report then select Ok.

Micronet displays a User Defined Questions screen, which differs depending on the report layout you selected. This screen shows the User Defined Questions screen for the Customer Simple report layout.

Enter or select the starting and ending values for the report (e.g. debtor IDs, debtor names or sales territories).

Select the Ok button.

Micronet displays the Select Output Device screen.

Select whether you want the report displayed on screen, printed, saved to a specific type of file, faxed, or emailed in a specific format.

Reference

For more details on these options, refer to "Selecting the Output for Inquiries and Reports".

Micronet prints or displays the Aged Trial Balance in the selected sort order and selected report layout.

If you selected to view the report, select the Drill button on any red text to display additional detail, e.g. the individual outstanding transactions on a customer's account.

You can keep drilling on the new report displayed if it contains red text, e.g. to view the individual invoice details including the items sold to the customer.